---
displayed_sidebar: "Chinese"
---

# md5sum_numeric

## 功能

计算多个输入参数的 MD5 128-bit 校验和 (checksum), 返回 MD5 值的十进制表示。

## 语法

```Haskell
LARGEINT md5sum_numeric(VARCHAR expr,...);
```

## 参数说明

`expr`: 支持的数据类型为 VARCHAR。

## 返回值说明

返回值的数据类型为 LARGEINT。如果输入为空，则返回报错。

## 示例

```Plain Text
mysql> select md5sum_numeric("starrocks");
+-----------------------------------------+
| md5sum_numeric('starrocks')             |
+-----------------------------------------+
| -11520983448139153100410741047322116235 |
+-----------------------------------------+
1 row in set (0.01 sec)

mysql> select md5sum_numeric("starrocks","star");
+-----------------------------------------+
| md5sum_numeric('starrocks', 'star')     |
+-----------------------------------------+
| 163436627872604162110984707546327199448 |
+-----------------------------------------+
1 row in set (0.01 sec)

mysql> select md5sum_numeric(null);
+-----------------------------------------+
| md5sum_numeric(NULL)                    |
+-----------------------------------------+
| -58332598431525814501020785164969033090 |
+-----------------------------------------+
```
